[dbo].[CM5Migration]

SQLServer > iMIS1521GA > Tables > dbo.CM5Migration

Properties
Columns
SQL Script
Uses

Property	Value
Heap
Row Count	0
Created	10:31:15 AM Tuesday, March 02, 2010
Last Modified	10:31:15 AM Tuesday, March 02, 2010

Columns

Name	Data Type	Max Length (Bytes)	Default
ImportItemID	varchar(50)	50
ImportItemType	varchar(50)	50
NewItemKey	uniqueidentifier	16
ImportedDateTime	datetime	8	(getdate())
Message	ntext	max

SQL Script

CREATE TABLE [dbo].[CM5Migration]
(
[ImportItemID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ImportItemType] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NewItemKey] [uniqueidentifier] NULL,
[ImportedDateTime] [datetime] NULL CONSTRAINT [DF_CM5Migration_ImportedDateTime] DEFAULT (getdate()),
[Message] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

Uses